<!DOCTYPE html>
<html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-0 vector-toc-not-available vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-0 skin-theme-clientpref-day vector-sticky-header-enabled" lang="de" dir="ltr"><head>
<meta charset="UTF-8">
<title>OpenRefine</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="icon" type="image/png" href="./_res_/favicon.png">
<link rel="canonical" href="https://de.wikipedia.org/wiki/OpenRefine"> <link href="./_mw_/ext.cite.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.wikimediamessages.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.icons.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.search.codex.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.styles.css" rel="stylesheet" type="text/css">
<meta name="ResourceLoaderDynamicStyles" content="">
<link href="./_mw_/ext.gadget.citeRef.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.defaultPlainlinks.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.dewikiCommonHide.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.dewikiCommonLayout.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.dewikiCommonStyle.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.dewikiDarkmode.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.dewikiResponsive.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.gadget.specialSearch.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="./_mw_/site.styles.css">
<link rel="stylesheet" type="text/css" href="./_mw_/noscript.css">
<link rel="stylesheet" type="text/css" href="./_res_/footer.css">
<link rel="stylesheet" type="text/css" href="./_res_/vector-2022.css">
</head>
<body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-OpenRefine rootpage-OpenRefine skin-vector-2022 action-view">
<div class="mw-page-container">
<div class="mw-page-container-inner">
<div class="mw-content-container">
<main id="content" class="mw-body">
<header class="mw-body-header vector-page-titlebar">
<h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">OpenRefine</span></h1>
</header>
<a id="top"></a>
<div id="bodyContent" class="vector-body ve-init-mw-desktopArticleTarget-targetContainer" aria-labelledby="firstHeading" data-mw-ve-target-container="">
<div id="contentSub">
<div id="mw-content-subtitle"></div>
</div>
<div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="de" dir="ltr"><div class="mw-content-ltr mw-parser-output" lang="de" dir="ltr"><table class="float-right infobox toccolours toptextcells" style="border-spacing:5px; font-size:90%; text-align:left; width:21em;">
<tbody><tr>
<th colspan="2" class="hintergrundfarbe6" style="font-size:105%; text-align:center;">OpenRefine
<p class="mw-empty-elt">
</p>
</th></tr>
<tr>
<td colspan="2" class="notheme" style="text-align:center; background-color:#f8f9fa;"><span typeof="mw:File"></span>
</td></tr>
<tr>
<th colspan="2" class="hintergrundfarbe5" style="font-size:105%; text-align:center;">Basisdaten
<p class="mw-empty-elt">
</p>
</th></tr>
<tr>
<td><b><a href="Softwareentwickler" title="Softwareentwickler">Entwickler</a></b>
</td>
<td><span class="wikidata-content"><a href="Google_LLC" title="Google LLC">Google</a>, <a href="Metaweb" title="Metaweb">Metaweb</a>, Antonin Delpeuch<sup id="cite_ref-_cde54d82f54b8cf1_1-0" class="reference"><a href="#cite_note-_cde54d82f54b8cf1-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup></span>
</td></tr>
<tr>
<td><b>Aktuelle <a href="Version_(Software)" title="Version (Software)">Version</a></b>
</td>
<td><span class="wikidata-content">3.9.5<sup id="cite_ref-_ebf4833a36039ace_2-0" class="reference"><a href="#cite_note-_ebf4833a36039ace-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup></span> <br> (<span class="wikidata-content">2. September 2025</span>)
</td></tr>
<tr>
<td><b>Aktuelle Vorabversion</b>
</td>
<td><span class="wikidata-content">3.9.4<sup id="cite_ref-_d3de3578e5964434_3-0" class="reference"><a href="#cite_note-_d3de3578e5964434-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup></span> <br> (<span class="wikidata-content">2. September 2025</span>)
</td></tr>
<tr>
<td><b><a href="Betriebssystem" title="Betriebssystem">Betriebssystem</a></b>
</td>
<td><span class="wikidata-content"><a href="Microsoft_Windows" title="Microsoft Windows">Microsoft Windows</a>, <a href="MacOS" title="MacOS">macOS</a>, <a href="Linux" title="Linux">Linux</a></span>
</td></tr>
<tr>
<td><b><a href="Programmiersprache" title="Programmiersprache">Programmiersprache</a></b>
</td>
<td><span class="wikidata-content"><a href="Java_(Programmiersprache)" title="Java (Programmiersprache)">Java</a><sup id="cite_ref-_1d4e3c62279c3fe9_4-0" class="reference"><a href="#cite_note-_1d4e3c62279c3fe9-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup>, <a href="JavaScript" title="JavaScript">JavaScript</a></span>
</td></tr>
<tr>
<td><b>Lizenz</b>
</td>
<td><span class="wikidata-content"><a href="BSD-Lizenz" title="BSD-Lizenz">BSD-Lizenz</a></span>
</td></tr>
<tr>
<td class="hintergrundfarbe5" colspan="2" style="text-align:center;"><a rel="nofollow" class="external text" href="https://openrefine.org/">openrefine.org</a>
</td></tr></tbody></table>
<p><b>OpenRefine</b> ist ein in <a href="Java_(Programmiersprache)" title="Java (Programmiersprache)">Java</a> geschriebenes Programm zur Bereinigung und Umwandlung von Daten.<sup id="cite_ref-5" class="reference"><a href="#cite_note-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> Die Software wurde im Jahr 2010 von <a href="Google_LLC" title="Google LLC">Google LLC</a> veröffentlicht und später als <a href="Freie_Software" title="Freie Software">Freie Software</a> bereitgestellt.<sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup> Es sind neben <a href="CSV_(Dateiformat)" title="CSV (Dateiformat)">CSV</a>, <a href="Microsoft_Excel" title="Microsoft Excel">XLS</a>, <a href="JavaScript_Object_Notation" class="mw-redirect" title="JavaScript Object Notation">JSON</a> oder <a href="Extensible_Markup_Language" title="Extensible Markup Language">XML</a> weitere Datenformate beim Import möglich, unter anderem kann man sich direkt mit Datenbanken verbinden.<sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup>
</p><p>Daten können mit dem Programm geordnet, bereinigt, transformiert, zergliedert und an vorhandenen <a href="Wikidata" title="Wikidata">Wikidata</a>-Einträgen ausgerichtet werden.<sup id="cite_ref-8" class="reference"><a href="#cite_note-8"><span class="cite-bracket">[</span>8<span class="cite-bracket">]</span></a></sup> Es arbeitet in Spaltendarstellung ähnlich einer <a href="Tabellenkalkulation" title="Tabellenkalkulation">Tabellenkalkulation</a>.<sup id="cite_ref-9" class="reference"><a href="#cite_note-9"><span class="cite-bracket">[</span>9<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="Weblinks">Weblinks</h2></div>
<ul><li><a rel="nofollow" class="external free" href="https://openrefine.org/">https://openrefine.org/</a></li>
<li><a rel="nofollow" class="external text" href="https://www.youtube.com/watch?v=-v6Ob6kPe-Y">Vorstellung OpenRefine</a></li></ul>
<div class="mw-heading mw-heading2"><h2 id="Einzelnachweise">Einzelnachweise</h2></div>
<ol class="references">
<li id="cite_note-_cde54d82f54b8cf1-1"><span class="mw-cite-backlink"><a href="#cite_ref-_cde54d82f54b8cf1_1-0">↑</a></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/graphs/contributors"><cite style="font-style:italic">github.com</cite>.</a> In: <cite style="font-style:italic">GitHub</cite>.</span>
</li>
<li id="cite_note-_ebf4833a36039ace-2"><span class="mw-cite-backlink"><a href="#cite_ref-_ebf4833a36039ace_2-0">↑</a></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.9.5"><cite style="font-style:italic"><span lang="en">OpenRefine 3.9.5</span></cite>.</a> 2. September 2025.</span>
</li>
<li id="cite_note-_d3de3578e5964434-3"><span class="mw-cite-backlink"><a href="#cite_ref-_d3de3578e5964434_3-0">↑</a></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.9.4"><cite style="font-style:italic"><span lang="en">Release 3.9.4</span></cite>.</a> 2. September 2025.</span>
</li>
<li id="cite_note-_1d4e3c62279c3fe9-4"><span class="mw-cite-backlink"><a href="#cite_ref-_1d4e3c62279c3fe9_4-0">↑</a></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://www.openhub.net/p/openrefine/analyses/latest/languages_summary"><cite style="font-style:italic"><span lang="en">The openrefine Open Source Project on Open Hub: Languages Page</span></cite>.</a> In: <cite style="font-style:italic">Open Hub</cite>. (abgerufen am 19. Juli 2018).</span>
</li>
<li id="cite_note-5"><span class="mw-cite-backlink"><a href="#cite_ref-5">↑</a></span> <span class="reference-text"><span class="cite"><a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine"><i>OpenRefine/OpenRefine.</i></a> OpenRefine, 29. Januar 2021,<span class="Abrufdatum"> abgerufen am 30. Januar 2021</span>.</span><span style="display: none;" class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Adc&rfr_id=info%3Asid%2Fde.wikipedia.org%3AOpenRefine&rft.title=OpenRefine%2FOpenRefine&rft.description=OpenRefine%2FOpenRefine&rft.identifier=https%3A%2F%2Fgithub.com%2FOpenRefine%2FOpenRefine&rft.publisher=OpenRefine&rft.date=2021-01-29"> </span></span>
</li>
<li id="cite_note-6"><span class="mw-cite-backlink"><a href="#cite_ref-6">↑</a></span> <span class="reference-text"><span class="cite"><a rel="nofollow" class="external text" href="https://openrefine.org/blog/2013/10/12/openrefine-history.html"><i>OpenRefine History · OpenRefine.</i></a><span class="Abrufdatum"> Abgerufen am 30. Januar 2021</span>.</span><span style="display: none;" class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Adc&rfr_id=info%3Asid%2Fde.wikipedia.org%3AOpenRefine&rft.title=OpenRefine+History+%C2%B7+OpenRefine&rft.description=OpenRefine+History+%C2%B7+OpenRefine&rft.identifier=https%3A%2F%2Fopenrefine.org%2Fblog%2F2013%2F10%2F12%2Fopenrefine-history.html"> </span></span>
</li>
<li id="cite_note-7"><span class="mw-cite-backlink"><a href="#cite_ref-7">↑</a></span> <span class="reference-text">Ruben Verborgh, Max De Wilde: <cite style="font-style:italic">Using OpenRefine</cite>. Packt Publishing Ltd, 2013, ISBN 978-1-78328-909-7 (<a rel="nofollow" class="external text" href="https://books.google.de/books?id=_WG1AAAAQBAJ&printsec=frontcover&dq=openrefine&hl=de&sa=X&ved=2ahUKEwiww9G0ssTuAhUzJMUKHVAJCccQ6AEwAHoECAMQAg#v=onepage&q=openrefine&f=false">google.de</a> [abgerufen am 30. Januar 2021]).<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rfr_id=info:sid/de.wikipedia.org:OpenRefine&rft.au=Ruben+Verborgh%2C+Max+De+Wilde&rft.btitle=Using+OpenRefine&rft.date=2013&rft.genre=book&rft.isbn=9781783289097&rft.pub=Packt+Publishing+Ltd" style="display:none"> </span></span>
</li>
<li id="cite_note-8"><span class="mw-cite-backlink"><a href="#cite_ref-8">↑</a></span> <span class="reference-text">Ying Tan, Yuhui Shi: <cite style="font-style:italic">Data Mining and Big Data: 4th International Conference, DMBD 2019, Chiang Mai, Thailand, July 26–30, 2019, Proceedings</cite>. Springer, 2019, ISBN 978-981-3295-63-6 (<a rel="nofollow" class="external text" href="https://books.google.de/books?id=bDulDwAAQBAJ&pg=PA73&dq=openrefine+wikidata&hl=de&sa=X&ved=2ahUKEwjD9Y2Ms8TuAhXzwAIHHQC2Bs0Q6AEwAHoECAQQAg#v=onepage&q=openrefine%20wikidata&f=false">google.de</a> [abgerufen am 30. Januar 2021]).<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rfr_id=info:sid/de.wikipedia.org:OpenRefine&rft.au=Ying+Tan%2C+Yuhui+Shi&rft.btitle=Data+Mining+and+Big+Data%3A+4th+International+Conference%2C+DMBD+2019%2C+Chiang+Mai%2C+Thailand%2C+July+26-30%2C+2019%2C+Proceedings&rft.date=2019&rft.genre=book&rft.isbn=9789813295636&rft.pub=Springer" style="display:none"> </span></span>
</li>
<li id="cite_note-9"><span class="mw-cite-backlink"><a href="#cite_ref-9">↑</a></span> <span class="reference-text">Seth van Hooland, Ruben Verborgh: <cite style="font-style:italic">Linked Data for Libraries, Archives and Museums: How to clean, link and publish your metadata</cite>. Facet Publishing, 2014, ISBN 978-1-85604-964-1 (<a rel="nofollow" class="external text" href="https://books.google.de/books?id=nuEqDgAAQBAJ&pg=PA95&dq=openrefine&hl=de&sa=X&ved=2ahUKEwiww9G0ssTuAhUzJMUKHVAJCccQ6AEwAXoECAcQAg#v=onepage&q=openrefine&f=false">google.de</a> [abgerufen am 30. Januar 2021]).<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rfr_id=info:sid/de.wikipedia.org:OpenRefine&rft.au=Seth+van+Hooland%2C+Ruben+Verborgh&rft.btitle=Linked+Data+for+Libraries%2C+Archives+and+Museums%3A+How+to+clean%2C+link+and+publish+your+metadata&rft.date=2014&rft.genre=book&rft.isbn=9781856049641&rft.pub=Facet+Publishing" style="display:none"> </span></span>
</li>
</ol></div><!--htdig_noindex--><div><div class="zim-footer">
Dieser Artikel wurde von <a class="external text" title="Zuletzt bearbeitet am 2024-04-11" href="https://de.wikipedia.org/wiki/?title=OpenRefine&oldid=243963630">Wikipedia</a> herausgegeben. Der Text ist unter <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.de">Creative Commons Attribution-Share Alike 4.0</a> verfügbar, sofern nicht anders angegeben. Für die Mediendateien können zusätzliche Bedingungen gelten.
</div>
</div><!--/htdig_noindex--></div>
</div>
</main>
</div>
</div>
</div>
<script src="./_webp_/webpHandler.js"></script>
</body></html>